Computer Programming: The Most Complete Crash Course for Learning The Perfect Skills To Coding Your Project Even If You Are an Absolute Beginner. Learn and Master The Best Programming Languages! by CODING HOOD & Michail Kölling

Author:CODING HOOD & Michail Kölling [HOOD, CODING]
Language: eng
Format: azw3
Publisher: Independent
Published: 2021-01-31T16:00:00+00:00

Granting and revoking a privilege

A role can be seen as a combination of privileges. When a user has a certain role, it inherits the set of privileges that the role has. Also, SQL Server allows developers to use DCL (Data Control Language) to control privileges.

You can grant and revoke privileges using certain statements. Here we will discuss them in brief for your better understanding.

GRANT

By using this statement, you can allow all your roles to certain users. If this privilege is not given, then it is difficult to operate as you expected.

Here is the SQL statement:

GRANT {Enter parameters} USER {Enter usernames}

REVOKE

By using this statement, you can stop the privileges or special permissions that you have given to the user before. By this statement, you can cut down the user access easily to maintain security in the system.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.